MICROSOFT 2000 MCDBA TRAINING CURRICULUM

  1. Exam 70-215: Installing, Configuring and Administering Microsoft Windows 2000 Server
  2. Exam 70-216: Implementing and Administering a Microsoft Windows 2000 Network Infrastructure
  3. Exam 70-228: Installing, Configuring, and Administering Microsoft SQL Server 2000 Enterprise Edition
  4. Exam 70-229: Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition

I. Exam 70-215: Installing, Configuring and Administering Microsoft Windows 2000 Server

  • Windows 2000 - New Features and Architecture
  • 3 Hours

  • Windows 2000 Installation
  • 5 Hours

  • Windows 2000 Administration
  • 3 Hours

  • Windows 2000 Users
  • 3.25 Hours

  • Windows 2000 - Groups and Terminal Services
  • 3.50 Hours

  • Windows 2000 - Files and Folders
  • 4 Hours

  • Windows 2000 - Advanced File and Folder Management
  • 3.75 Hours

  • Windows 2000 - Hardware Configuration & Optimization
  • 6.25 Hours

  • Windows 2000 - Storage and Printing
  • 5.50 Hours

  • Windows 2000 Events
  • 3 Hours

  • Windows 2000 - Backup and Recovery
  • 3.75 Hours

  • Windows 2000 - Group Policy
  • 6.25 Hours

  • Windows 2000 - Network Protocols and Remote Access
  • 3.25 Hours


    II. Exam 70-216: Implementing and Administering a Microsoft Windows 2000 Network Infrastructure

  • Windows 2000 Implementing a Network Infrastructure: Addressing and Naming Services
  • 4 Hours

  • Windows 2000 - Implementing a Network Infrastructure: IP Routing
  • 4 Hours

  • Windows 2000 - Implementing a Network Infrastructure: Security
  • 5.25 Hours

  • Windows 2000 - Implementing a Network Infrastructure: Network Protocols and Remote Access
  • 3.25 Hours


    III. Exam 70-228: Installing, Configuring, and Administering Microsoft SQL Server 2000 Enterprise Edition

  • Overview of SQL Server 2000
  • 1.75 Hours

  • Installing, Configuring and Upgrading SQL Server 2000
  • 2 Hours

  • SQL Server 2000 Databases
  • 1.75 Hours

  • Transferring and Transforming Data in SQL Server 2000
  • 1.50 Hours

  • Security in a Microsoft SQL Server 2000 Environment
  • 2 Hours

  • Managing SQL Server 2000 Databases
  • 2.75 Hours

  • Backing Up SQL Server 2000 Databases
  • 2.25 Hours

  • Restoring SQL Server 2000 Databases
  • 1.75 Hours

  • SQL Server 2000 Replication
  • 1.75 Hours

  • Monitoring SQL Server 2000 Performance
  • 1.50 Hours

  • SQL Server 2000 High Availability
  • 1 Hour

  • SQL Server 2000, XML and the Web
  • 1.50 Hours


    IV. Exam 70-229: Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition

  • Overview of SQL Server 2000
  • 1.75 Hours

  • SQL Server 2000 Databases
  • 1.75 Hours

  • Designing and Implementing Security in SQL Server 2000
  • 1.25 Hours

  • The SQL Server 2000 Logical Data Model
  • 2.50 Hours

  • Using T-SQL in SQL Server 2000
  • 3 Hours

  • SQL Server 2000 Indexes
  • 2 Hours

  • SQL Server 2000 Programming and Business Logic
  • 2.75 Hours

  • SQL Server 2000 Transactions and Distributed Data
  • 1.75 Hours

  • Analyzing and Optimizing SQL Server 2000 Queries
  • 1.75 Hours

  • Transferring and Transforming Data in SQL Server 2000
  • 1.50 Hours

  • SQL Server 2000, XML and the Web
  • 1.50 Hours